package net.qunzhi.modules.cms.dao;

import cn.hutool.core.lang.Pair;
import net.qunzhi.modules.cms.entity.TbFlowStateEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.qunzhi.modules.cms.query.DailyRecordListQuery;
import net.qunzhi.modules.cms.vo.WaterSellConditionOfEachFlowmeterVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 调度中心流量数据
 * 
 * @author zjr
 * @date 2021-09-10 15:48:00
 */
@Mapper
public interface TbFlowStateDao extends BaseMapper<TbFlowStateEntity> {

    String getMaxTimeByEquipmentId(Integer id);

/*cpk*/

    List<Pair<String, Object>> getDaliyFlowById(@Param("id") Integer id,@Param("startDate")String startDate,@Param("endDate")String endDate);

    List<Pair<String, Object>> getCopyDailyFlowByAreaId(@Param("areaid") Integer areaid,@Param("startDate")String startDate,@Param("endDate")String endDate);

    List<Pair<String, Object>> getXjDailySellList(@Param("startDate") String startDate, @Param("endDate") String endDate);

    List<Pair<String, Object>> getSanShuiDailyFlow(@Param("startDate") String startDate,@Param("endDate") String endDate);

    List<Pair<String, Object>> getDanZaoDailyFlow(@Param("startDate") String startDate,@Param("endDate") String endDate);

    List<Pair<String, Object>> getJinShaDailyFlow(@Param("startDate") String startDate,@Param("endDate") String endDate);

    List<Pair<String, Object>> getChanchengDailyFlow(@Param("startDate") String startDate,@Param("endDate") String endDate);

    List<Pair<String, Object>> getNanJiangDailyFlow(@Param("startDate") String startDate,@Param("endDate") String endDate);

    List<Pair<String, Object>> getMorningWaterOfFlowMeterById(@Param("id") Integer id, @Param("startDate") String startDate,@Param("endDate") String endDate);


    //获取手抄数据 要与上面的名字区分开来
    List<Pair<String, Object>> getCopyDailyFlowById(@Param("areaid") Integer areaid,@Param("startDate")String startDate,@Param("endDate")String endDate);

    List<Pair<String, Object>> getCopyXjDailySellList(@Param("startDate") String startDate,@Param("endDate") String endDate);

    Object getCumulativeWaterOfSanShui(@Param("startDate") String startDate);

    Object getCumulativeWaterOfDanZao(@Param("startDate") String startDate);

    Object getCumulativeWaterOfJinSha(@Param("startDate") String startDate);

    Object getCumulativeWaterOfChanCheng(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfSanShui(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfDanZao(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfJinSha(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfChanCheng(@Param("startDate")String startDate);

    Object getCopyCumulativeWaterOfXiQiao(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfXjSupply(@Param("startDate") String startDate);

    Object getCopyCumulativeWaterOfXjDraw(@Param("startDate") String startDate);


    //List<Map<String, Object>> getChanChengSellDaily(@Param("dateTime")String dateTime);
}
